<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Restoring a ClickHouse Database or Table Set">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000001792543176.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20240608">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000001792383424">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Restoring a ClickHouse Database or Table Set</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000001792383424"></a><a name="EN-US_TOPIC_0000001792383424"></a>

<h1 class="topictitle1">Restoring a ClickHouse Database or Table Set</h1>
<div><p>This section describes how to restore a ClickHouse database or table set that has been backed up to the original or a new location.</p>
<div class="section"><h4 class="sectiontitle">Prerequisites</h4><ul><li>For restoration of ClickHouse databases or table sets using copies to a new cluster, the target cluster must be homogeneous.</li><li>When restoring data to the original or new location, ensure that the remaining space of the target location is greater than the size of the restoration copy before reduction. Otherwise, the restoration fails.</li></ul>
</div>
<div class="section"><h4 class="sectiontitle">Procedure</h4><ol><li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000001792383424__en-us_topic_0000001839142377_uicontrol164769252279"><b><span id="EN-US_TOPIC_0000001792383424__en-us_topic_0000001839142377_text1947682515279"><strong>Explore</strong></span> &gt; <span id="EN-US_TOPIC_0000001792383424__en-us_topic_0000001839142377_text17476122515275"><strong>Copy Data</strong></span> &gt; <span id="EN-US_TOPIC_0000001792383424__en-us_topic_0000001839142377_text16945959017"><strong>Big Data</strong></span> &gt; <span id="EN-US_TOPIC_0000001792383424__en-us_topic_0000001839142377_text3314918173412"><strong>ClickHouse</strong></span></b></span>.</span></li><li><span>Search for copies by ClickHouse resource or copy. This section describes how to search for copies by resource.</span><p><p>On the <span class="uicontrol"><b><span><strong>Resources</strong></span></b></span> tab page, locate the database or table set to be restored by resource name and click the name.</p>
</p></li><li><span>Select the year, month, and day in sequence to find the copy.</span><p><p>If <span><img src="en-us_image_0000001792543212.png"></span> is displayed below a month or day, a copy is generated in that month or day.</p>
</p></li><li><span>Restore data using a specific copy.</span><p><ol type="a"><li>Common restoration<ol class="substepthirdol"><li>In the row where the copy to be restored resides, choose <span class="menucascade"><b><span class="uicontrol"><span><strong>More</strong></span></span></b> &gt; <b><span class="uicontrol"><span><strong>Restore</strong></span></span></b></span>.</li><li>Restore the ClickHouse database or table set to its original or a new location.<div class="p"><a href="#EN-US_TOPIC_0000001792383424__table13681910173115">Table 1</a> describes related parameters.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000001792383424__table13681910173115"></a><a name="table13681910173115"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001792383424__table13681910173115" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Restoring a ClickHouse database or table set</caption><colgroup><col style="width:32.019999999999996%"><col style="width:67.97999999999999%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="32.019999999999996%" id="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="67.97999999999999%" id="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="32.019999999999996%" headers="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.1 "><p><span><strong>Restore To</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="67.97999999999999%" headers="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.2 "><p>Select either <span class="uicontrol"><b><span><strong>Original location</strong></span></b></span> or <span class="uicontrol"><b><span><strong>New location</strong></span></b></span>.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="32.019999999999996%" headers="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.1 "><p><span><strong>Location</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="67.97999999999999%" headers="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.2 "><p>If you select <span class="uicontrol"><b><span><strong>Original location</strong></span></b></span> for the <strong>Restore To</strong> parameter, the original location is displayed.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="32.019999999999996%" headers="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.1 "><p><span><strong>Target Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="67.97999999999999%" headers="mcps1.3.3.2.4.2.1.1.1.2.1.2.2.3.1.2 "><p>Target cluster for restoration, which is mandatory if you select <span class="uicontrol"><b><span><strong>New location</strong></span></b></span> for the <strong>Restore To</strong> parameter.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</li><li>Click <span class="uicontrol"><b><span><strong>OK</strong></span></b></span>.</li><li>In the displayed dialog box, confirm the information and click <span class="uicontrol"><b>OK</b></span>.<p><span><img src="en-us_image_0000001839182589.png"></span></p>
<p></p>
</li></ol>
</li><li>Table-level restoration<ol class="substepthirdol"><li>In the row where the copy to be restored resides, choose <span class="menucascade"><b><span class="uicontrol"><span><strong>More</strong></span></span></b> &gt; <b><span class="uicontrol"><span><strong>Table-level Restoration</strong></span></span></b></span>.</li><li>Select the table to be restored.</li><li>Select the target cluster for restoration. <a href="#EN-US_TOPIC_0000001792383424__table13681910173115">Table 1</a> describes related parameters.</li><li>Click <span class="uicontrol"><b><span><strong>OK</strong></span></b></span>.</li><li>In the displayed dialog box, confirm the information and click <span class="uicontrol"><b>OK</b></span>.<p><span><img src="en-us_image_0000001792383484.png"></span></p>
</li></ol>
</li></ol>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000001792543176.html">Restoration</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>